SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150418 LIMIT 1 [ RunTime:0.000979s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150418 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274471,343347,599919,376146,535947,784707,746923,87301,170210,1048231,218169,476456,396725,1028842,685436,675252,758520,159725,287180,790378,766185,803591,538074,797243,10231,395213,296925,327778,817474,949863,256943,410440,805749,234197,564641,212253,90703,143432,987460,1030222,636174,869430,299917,290622,920784,199407,134864,760298,579899,853779,78790,17445,171551,624472,776068,437911,386734,398595,587426,795026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002254s ]