SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 11883 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 11883 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987597,88750,217389,235029,297216,797778,435640,339752,559083,1001756,501281,871240,309105,411219,966406,900966,620911,1038307,835093,487832,446236,834542,304707,726598,616283,997319,659640,372277,630087,719025,742761,355137,274655,435645,642454,847087,234484,813552,261593,604057,763080,991623,231143,941969,776264,922688,940651,1031456,433176,878471,399711,529561,740266,794256,798450,411445,1007137,598104,872947,855915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 11883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 11883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]