SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449953 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449953 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (389494,769229,656872,819386,999556,225430,469039,531254,1045709,917045,405736,23508,811525,299031,650684,238598,230220,142722,76384,283376,226007,967607,670669,1017952,281102,557519,881996,887940,574966,885568,813948,782415,12910,1004303,1018843,354809,22277,231269,943421,965107,85995,219291,803753,993547,526496,676716,273890,158948,31232,547432,353770,965152,215570,970965,449468,1043257,193907,474558,426690,506340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]