SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400113 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400113 [ RunTime:0.002253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928521,694828,420554,612711,358307,153659,802253,773188,426512,122393,235124,321461,773938,244274,819844,405066,827540,290346,500579,243031,552570,544886,205030,145628,503251,870271,89996,92396,557782,57463,466906,593539,526114,964934,446548,928,111358,257277,412773,438394,359570,823320,501213,622599,1002000,53588,826868,141709,1027144,23231,774163,274332,887308,248162,784160,960069,838099,279632,673116,616594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]