SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 229180 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 229180 [ RunTime:0.002430s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445093,815702,865554,371025,424718,322493,145242,1033668,703150,108579,1019522,55996,434414,962685,1048820,631375,398632,256072,759796,614588,189099,406999,375121,796754,653038,420338,623797,67604,475857,28423,1048883,1041411,309778,942803,624638,657294,246239,847860,422273,1013730,1029604,834495,8831,20296,761406,629012,351687,356949,292650,185018,543765,504281,446037,958241,336639,840042,12923,116680,83717,213600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 229180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 229180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]