SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 787840 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 787840 [ RunTime:0.003438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353810,132169,158800,1044292,805675,354457,198419,763078,932604,392067,449190,433407,332457,288561,359266,775028,1030459,200433,202355,437902,128735,440396,925702,86399,51556,286642,1032341,589786,2972,1043790,446483,694200,817841,36890,33304,676724,620272,488144,884746,33112,988641,170160,746301,453444,90359,823641,707074,937384,734253,729581,1008625,807926,479873,748224,436029,872364,951493,448355,345369,245792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 787840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 787840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]