SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376894 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376894 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808981,49835,895849,68797,798084,712754,862284,534371,461794,619301,963640,606743,376748,909025,657541,309100,544315,132212,463893,587883,751601,805508,574333,589439,591074,576871,1027095,240128,493718,59024,877908,67151,496906,718151,655556,257193,40091,357823,163157,246239,570415,486355,897513,682851,421394,895431,445440,564312,497651,601540,286176,482084,793858,633118,348500,897887,471697,501762,369260,15498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003324s ]