SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416510 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416510 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37201,696694,374306,740169,18149,803557,479238,889390,946333,374317,902017,703826,500267,752541,632848,267190,371437,176772,849011,578077,45241,767677,771769,860100,474666,899979,494070,51123,83148,949176,154394,669059,905135,419196,515760,943094,714968,425035,848165,842241,3138,984298,28397,988160,416691,659221,369803,683297,535316,915466,657705,447794,825418,88572,149607,449983,994974,570487,177579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]