SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583618 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583618 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69692,62230,117644,621921,713656,432878,280132,379050,987578,459664,471140,953994,337545,955422,567032,111731,598267,841188,658538,401906,232885,750920,502129,5907,203583,790968,917734,496641,403748,609614,377740,58098,344328,761817,149314,1031498,196073,599179,928458,23696,1025223,242821,819117,114070,31307,340754,495647,310817,705100,770527,707760,108177,181613,934024,634523,345480,849300,280338,346935,523182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]