SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501470 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501470 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337747,626180,815823,353,23580,847370,368067,200251,448547,273430,266532,669481,337704,900917,780844,696673,909724,704380,829208,429669,42348,138616,652786,1004562,67139,723316,318633,495608,612703,930988,217229,491874,983551,458059,746724,318643,370596,464910,873681,220723,390884,899098,566301,989734,928982,453372,558873,948797,664475,370617,776581,106622,171623,476184,562436,438638,539221,576718,390712,1019791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]