SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527433 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527433 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313432,318069,145071,822443,263410,972555,506846,761168,555187,506338,669630,616639,1044499,917224,415181,944303,216961,724292,291266,413170,469463,894607,274143,625973,957311,225579,142631,273221,609969,757055,777161,43585,216546,882309,825807,937121,41424,612370,449325,178264,480703,112127,394490,834453,432529,71219,1042408,1024329,327061,29588,846529,1033939,427934,6360,188192,711014,236491,515315,884186,270841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]