SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349180 LIMIT 1 [ RunTime:0.002110s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349180 [ RunTime:0.005584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113794,1026338,562156,766934,392278,468915,376584,890427,711113,271153,982147,703191,415339,280765,879238,808900,51070,968255,748761,782506,721171,153418,831105,407949,163780,523263,963289,854387,766693,92885,1016460,877598,378595,150265,953207,643242,1040003,945947,1039281,135461,801782,777922,383526,583122,647211,885174,445488,538138,719920,355094,145266,617668,688010,238848,844732,289599,871570,880426,352903,450231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]