SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 985343 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 985343 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528818,989616,23417,431486,796534,265947,575705,225624,50134,685167,428814,666329,761174,750143,747672,58174,983853,43011,925162,589812,474285,1506,468932,94967,169774,826580,215359,386714,23074,872654,299993,670492,60239,993159,590575,867578,330001,232524,625549,229362,824753,846122,859859,98995,1002910,1045035,111672,132576,14026,689926,422655,843591,966385,232356,429508,90514,729872,728540,839010,846220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 985343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 985343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]