SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416614 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416614 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206709,97072,609515,881207,23383,312841,1034871,983507,786768,783678,368388,382958,293965,1006004,167812,515625,85795,290023,964818,652318,1015813,335730,103091,139484,754201,446715,527057,140934,149834,876448,169533,912999,288837,484185,655680,78562,123371,954903,1021329,520131,599536,253470,82011,500749,846804,231425,608734,623107,1033657,1011565,526790,915461,354814,534962,219570,602948,719501,715963,573076,244131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]