SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533520 LIMIT 1 [ RunTime:0.001981s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533520 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56212,421955,454446,275748,609144,89057,4568,1007642,91621,755734,208474,1037008,496660,335633,99037,61781,4607,482721,754599,894229,113493,850719,873894,1013081,227018,7655,291937,450364,988872,103954,432056,344328,729423,61709,378281,474322,518049,881269,1035308,307097,783144,944102,796368,982937,518454,805907,229893,653210,57364,488768,706577,148519,729622,35921,617854,583082,12173,354794,423977,506219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]