SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684712 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684712 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288827,224794,476318,196219,211857,145030,704132,24926,182095,252468,996879,801141,679500,692424,328889,334804,996037,609524,171848,623161,80313,754862,491877,982924,283973,287439,180776,8761,325520,778247,130758,303154,327737,596833,59894,176912,545140,706344,153168,815585,57471,1027189,332180,725810,141942,382083,989982,163807,444090,859528,985555,364410,369555,216571,674045,388999,722280,903823,387572,529955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]