SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419585 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419585 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613481,129813,514815,265785,39581,874408,143831,747418,518569,293321,379111,442998,742678,382386,236655,237573,474897,280999,188649,979548,854687,546956,820941,399279,34843,607650,423010,492395,632003,807793,986480,714628,245472,145927,446382,441501,487241,532451,803811,978233,572558,274180,674439,958254,831492,947307,1022418,898963,813402,161373,427341,279905,1008561,862788,771939,18759,231521,275705,77976,512739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]