SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401981 LIMIT 1 [ RunTime:0.001626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401981 [ RunTime:0.002106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840859,108122,430372,85715,882585,769762,39725,986839,669717,732727,768297,552672,925622,969545,861606,875518,107241,471908,660743,332987,266005,118377,997439,146120,901098,227418,423954,308975,459758,79753,952774,1022307,853275,1010852,7111,906714,553650,1022592,919498,162862,602220,963612,538675,323567,269787,9983,872879,306957,101997,998864,62510,908534,419013,187958,434701,947875,888849,762694,475430,515731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010873s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]