SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020845 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020845 [ RunTime:0.002592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596682,361050,19926,205659,427146,630052,639583,334816,42420,666862,946703,516095,675787,1020965,122514,834597,318334,244332,472638,1020554,1009259,744082,366789,1023695,722685,245407,763112,36326,141603,561343,783415,1009891,693752,720997,483439,986153,1040945,761903,1007927,563913,732793,575668,1029266,305488,761867,360769,41445,488180,322614,771664,580044,213624,187700,753786,930264,726299,44978,442430,408421,299727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]