SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299050 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299050 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327409,78105,1001140,167011,242577,567140,75159,713867,916427,267942,453913,435504,1030334,638577,456570,162277,928628,402524,414481,964437,349794,648361,371195,343550,912398,1035064,985919,781302,26480,795261,698359,132629,426131,538831,938237,1021578,858349,782166,516592,208351,1041674,859657,385961,245255,998259,316013,673239,691081,748142,525942,152269,544063,470027,72277,241787,653746,40031,1013975,373483,691538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]