SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173710 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173710 [ RunTime:0.002182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024480,978124,823676,520858,995205,329738,9325,863362,177309,848240,692445,584628,283198,469623,979650,525330,312803,94115,312358,232077,380485,536231,858359,637525,867756,1034267,215437,484166,779839,665075,92652,1038408,870487,222315,889977,565684,255469,428898,522916,770417,227532,157604,95084,281764,784760,581582,745879,769160,398271,911959,374489,527236,760319,36402,794767,756866,149822,9182,920003,186441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]