SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426422 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426422 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180307,366903,820774,331125,728340,158442,649839,658815,488568,4279,54388,481505,75404,922246,241225,1029708,934183,1030869,808644,972425,482311,56684,896144,25867,811038,165955,995344,423876,634309,343422,105056,1016263,520984,116338,22421,421946,959093,493935,646885,496334,1008161,168602,238862,761836,261831,305046,1032561,1015584,247295,109312,743778,650617,399785,442537,616290,472211,891736,1014437,243955,560079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]