SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318084 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318084 [ RunTime:0.002813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198821,900629,234986,730771,991011,930241,1009346,65549,235682,170085,357035,860756,83370,596210,355847,663348,754824,77136,962203,584120,168823,543009,765533,980778,443771,207189,910014,638654,305732,849106,688968,486600,773319,519645,10861,101393,178795,461979,575716,711734,678836,6856,976457,720974,577020,753715,883735,293470,896268,722108,1004980,170968,336601,336642,578780,205244,572711,129496,566545,496287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]