SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007760 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007760 [ RunTime:0.002740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455154,598853,83201,1028102,300079,764182,558589,260087,143375,84642,483527,467023,378419,909574,712150,161164,93262,777474,617953,71487,371436,837507,130294,444619,995159,826143,40784,744112,842208,725303,856301,546139,290646,272941,288967,135566,334668,184227,347738,408101,1042819,524582,51438,973080,967199,367174,197537,1022976,969092,264525,515318,528416,536454,672389,501174,922582,670299,610398,1014483,632615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]