SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510212 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510212 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356274,743298,161057,994943,562041,826543,290764,1000798,69362,862787,772948,983904,910883,661708,908933,830793,642553,390933,780067,836507,643990,244760,181929,1001880,530313,972342,201232,4977,234259,643401,866653,624775,855404,279655,876084,31485,256320,265871,1040326,555949,545863,723185,942827,402155,580356,313272,337775,7567,213163,29065,45048,861570,405544,409173,460989,533114,748132,973438,768741,2947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]