SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496730 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496730 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371589,541236,963382,653130,978584,148906,865392,449267,868549,29326,493814,807645,734016,423237,470011,952102,288988,257906,964367,634490,469398,547522,235691,748740,195732,647167,707419,516882,903365,691408,818493,726605,415763,372559,183150,1016283,576493,566657,941958,1040808,175629,159781,378386,813117,910189,726928,979228,571849,275410,16975,226861,827606,915581,639542,599514,161049,911822,307261,444850,782940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]