SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249738 LIMIT 1 [ RunTime:0.006319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249738 [ RunTime:0.008223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912116,656705,569390,364594,102918,155381,907417,900424,746910,898652,781101,902442,939795,68337,105486,285616,632421,646573,994012,814990,88891,542514,916065,736194,1023439,568900,866299,1006472,781509,360325,268230,783454,1033256,274119,891552,481538,128635,942602,40317,896164,968755,883415,549671,462080,254412,513328,1032710,879143,131065,570768,807403,368955,769356,961861,151476,1023016,961170,668907,684837,336460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]