SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502613 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502613 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35928,191065,707216,175359,396150,820825,653460,937165,283081,472316,768873,888648,268848,560247,103942,269007,82687,42006,834301,570942,939694,217583,799686,879743,1006879,623950,214165,280744,121724,869833,25035,798166,1031934,251999,526070,668365,784809,95185,131660,51781,460042,578716,16951,176992,572174,911545,626156,478460,495103,146937,656535,718095,333533,1024233,983690,375708,596580,562626,753285,953506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]