SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001751s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201568 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201568 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197430,771936,207797,546733,12892,271381,998917,131333,627135,691529,183061,699604,1022210,544641,1028960,1031034,38981,1030400,264004,153109,466280,768612,470215,566932,796661,367742,48798,496279,773259,15613,964634,842789,315260,821055,235161,988685,763887,268225,962804,166417,492393,87319,686743,991935,903587,835279,837207,341282,851874,952329,312322,80267,252617,276326,418929,668775,768473,808560,616505,843930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]