SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009313 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009313 [ RunTime:0.002219s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764850,718398,445287,47789,599713,519476,98762,469541,474873,406810,988650,53757,263247,479473,1046384,609518,785785,697424,291292,448658,806782,952647,144912,47878,421853,915035,123799,2201,226596,396335,583880,588041,1047812,3977,582384,252717,239907,664382,471443,1020758,370588,473397,436214,277800,358288,1022814,874997,402411,491390,789948,171139,42284,276887,463035,69765,741436,705596,216976,953702,340541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]