SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563081 LIMIT 1 [ RunTime:0.001019s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563081 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527314,424099,424881,686657,468049,637889,977470,999135,513316,960364,26437,1029437,363945,895984,138786,411761,349540,631665,337832,117225,728012,761991,104375,88398,420849,498080,1040091,251971,208445,8465,466589,386021,241732,213282,805879,140580,947180,1037326,390427,45237,596336,271131,704860,67974,158214,776744,527909,48573,926615,284072,504089,460958,912993,449984,474930,331443,764174,239297,826957,620770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001273s ]