SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286481 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286481 [ RunTime:0.005993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246702,979487,14367,859302,533754,772135,359795,129765,1031576,305981,112383,917759,43073,144750,138435,311643,777588,1024681,560149,827635,301615,398618,374940,82722,486481,51024,896732,544639,438394,375459,869487,197619,697291,502597,692594,245385,387612,792560,279243,21719,838399,894582,395047,712360,398530,24276,50212,587478,965749,759798,414761,653867,795701,661026,550096,167861,793843,208074,669376,446423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001194s ]