SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516071 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516071 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972042,71878,58311,532483,909736,355624,146688,997373,588706,876783,999863,693457,971659,677529,750717,413345,356664,913434,976708,1021533,915550,1124,326808,414390,940680,239451,686133,735894,410711,1032853,334695,583196,570207,508391,563889,574994,243951,834522,374424,750079,41458,708306,501445,66260,565879,569628,897636,915077,432003,95758,471656,1019957,812182,46413,68383,280210,50296,531309,83824,477034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]