SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505097 LIMIT 1 [ RunTime:0.000620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505097 [ RunTime:0.002038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932453,477455,610413,618512,801615,788200,370993,936859,605250,132073,957643,579384,310629,1022171,770810,135474,678073,45497,833274,541207,778465,379951,512045,323762,67275,638111,286120,999310,754470,796406,71438,583951,856899,551042,86603,710618,447474,336692,711612,771390,158966,1029659,869317,572931,8039,956432,797537,7810,662243,668738,155481,529155,216014,197912,442668,653142,475562,866352,503522,729268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]