SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101993 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101993 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473255,166458,94500,838628,70450,306099,364060,1041190,187339,413491,807213,577118,548786,858422,573254,344093,807971,393204,234135,983347,801324,372948,187160,970833,293733,986597,714263,465820,314113,151139,964378,121968,730309,281035,524243,887989,984033,134905,149287,604432,684422,957576,861838,981424,505,378174,441814,61940,204629,523021,553610,210409,74915,342572,197056,389527,491063,696810,183026,194395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]