SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463510 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463510 [ RunTime:0.002639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692833,610397,1022992,468923,613146,1025102,781733,676294,132111,853135,313812,842883,98639,253513,396373,228362,303411,189043,366840,668825,217254,657578,428816,918036,487040,658295,400049,351555,207631,67809,109251,30917,817581,674087,606396,744408,1043512,971096,368896,15856,587632,1032246,758525,504688,617855,834564,846518,541388,64054,992586,277069,44696,583970,901183,348933,90027,87310,648063,794964,795785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]