SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415984 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415984 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252543,834104,216251,346437,427178,636431,453113,903140,996719,603466,497517,723349,680316,428535,668419,45955,819543,759645,245779,65175,911694,224063,247845,33355,385922,1027227,559874,503537,796464,542597,609099,526079,675367,846355,254887,193678,616603,184516,919099,753870,371562,13976,144477,1027635,273325,355288,327652,24207,109791,1028239,886727,107282,754408,88973,968458,92399,856513,663832,900595,642016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]