SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249151 LIMIT 1 [ RunTime:0.000704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249151 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330018,110176,933779,503829,1000915,901119,679885,1039067,950966,420333,192568,679246,545485,485102,626969,418429,1030707,296546,748860,765741,57979,635900,1011452,382965,855215,59790,690915,645506,979114,987707,255047,1012390,619521,1009866,141478,653839,377244,807077,250999,594272,753019,264953,32400,811623,246362,200715,827026,531173,655765,855048,356707,151853,192354,715690,1001965,234285,252520,477792,245514,391813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]