SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577516 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577516 [ RunTime:0.002814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696758,60622,912710,196017,413591,40826,225405,643230,1040693,504501,494603,802887,216179,178629,64354,201510,16030,338118,580542,878068,883715,1038848,555312,998568,322853,914607,9178,670656,523440,156887,30,1025753,698948,589734,239314,206884,269813,169633,415746,193047,569832,353771,261665,235484,509580,779315,470510,438922,332164,784298,39274,738439,61557,389540,941639,900769,884016,967234,810537,925328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]