SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 248118 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 248118 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268555,842418,601093,289833,897295,106283,360425,524723,238241,458141,990910,202684,147752,969970,345322,63293,245281,53674,664852,259661,450411,219499,669548,271574,1006312,137564,51691,707433,511882,1039264,1023712,742910,851259,296907,1017956,736815,627151,540875,1019485,708972,849116,826133,919233,329597,951706,558087,813487,383211,168977,817665,1020848,452806,821589,595846,52159,685567,134587,854202,472507,981210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 248118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 248118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]