SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412206 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412206 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184960,821550,823337,446867,103705,88804,208433,56512,617074,1025638,197845,244190,924890,598866,369028,413324,93320,625348,856566,624726,89788,917991,31164,769583,710209,798028,1020252,264000,88681,379132,70678,728888,852859,677030,757113,434280,845037,193813,659885,246213,50892,332330,49424,272851,496193,356178,848161,503145,311916,548848,458231,806971,694699,339852,853220,500207,620678,821703,731475,856028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]