SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001619s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48317 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48317 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537355,221676,1030439,342240,1020366,198880,944420,574580,880713,564050,125241,913281,509320,231982,379989,489987,741258,204452,766369,204939,566193,1033856,450874,977749,191100,287306,340022,1018418,1009108,1031780,362254,614977,812672,220463,1004801,671780,388042,560150,978774,384067,40538,20107,701037,682710,582290,78827,755303,143641,470509,630268,834554,837350,531339,616575,819088,26281,1015319,539738,407715,694465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001130s ]