SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301723 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301723 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410711,47786,463780,994622,706568,34076,339869,235678,348242,96899,189519,871475,503644,703828,904074,1034146,953637,911094,740531,284466,922759,105627,611834,227089,425027,637205,717916,248318,979814,1003218,30888,944760,686720,179181,176346,263426,178620,225080,272454,560857,691335,601734,98718,18611,527671,1009338,223092,488084,625573,711570,655713,319735,615218,385287,189453,370840,397148,113192,880597,752349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001367s ]