SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401783 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401783 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888956,707244,597670,926637,80040,435637,254814,866191,320265,481063,73715,758730,36006,723471,533857,377967,417908,468137,660072,838338,324459,105349,198685,126948,274794,305660,244712,545653,338785,190048,295709,781556,187481,927701,607135,51084,721485,430348,682166,348561,564511,600637,430184,126558,933714,989221,121222,266696,160162,889213,552464,557278,765514,473647,159335,16459,85549,39537,178834,993952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401783 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401783 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]