SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171096 LIMIT 1 [ RunTime:0.000607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171096 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536098,1016409,985235,300400,890273,911315,224554,1042695,65802,791855,445165,267004,375464,498198,793206,137575,322699,791113,685517,28159,406501,891491,679264,191083,805607,840512,223026,693185,637973,781212,537919,32387,324084,5293,293059,170285,982714,626579,590158,364195,525517,192441,821235,499596,127289,388070,75890,588480,729800,273723,562545,940198,948762,114861,255760,608591,539398,937818,8065,594234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]