SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106983 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106983 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119016,519558,218136,171572,547777,921107,769234,936411,332139,715819,633623,274513,200697,646361,245721,929732,1005974,558391,476442,372134,73935,922201,28389,593186,927229,535331,876160,563634,517816,1000430,397694,548982,283108,145499,841701,923947,343204,889125,689144,932940,625502,205159,578796,456800,386827,688968,980701,801873,216624,726920,244874,343517,761164,469856,897241,939373,481371,840919,776920,881282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]