SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367741 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367741 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307596,5504,865052,501722,181604,494150,411043,378447,803962,890873,385503,560910,556619,14601,340674,1006720,715086,815405,349361,576119,857646,1040567,344486,737535,936696,235151,1004106,808435,869545,120983,660316,809011,142187,104089,15205,346280,198926,845475,420411,123012,561932,471345,781347,544928,199633,969141,817103,38131,403365,692671,1023661,225340,691505,941545,382331,558691,929587,986104,572407,520553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]