SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711823 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711823 [ RunTime:0.004450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422016,1048126,802723,714422,16250,490541,601076,395234,434547,163577,104975,374519,367339,13649,249841,604461,49969,239336,786697,475518,599582,418604,596009,838762,281687,530899,191888,378237,685800,661225,800739,209772,706492,244506,203677,572036,484884,499229,405154,826085,359862,957427,116754,292402,15994,51474,406621,873003,829103,983474,213065,424959,736222,25444,134842,281334,822240,581759,64476,654341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]