SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 155343 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 155343 [ RunTime:0.001412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483823,550564,270208,1007393,832123,306852,293807,970114,339517,717926,789109,135767,344418,147884,500364,611567,6821,658207,404430,596825,732839,507516,796366,274116,897710,785034,431142,17191,45835,70714,940904,780798,459461,880481,600789,254127,1045389,205918,454512,984025,459459,778193,275776,395828,505766,248698,779843,722279,91026,917635,849977,669923,319008,588000,240819,1001970,802118,597921,981386,496175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 155343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 155343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]