SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005870s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394212 LIMIT 1 [ RunTime:0.002908s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394212 [ RunTime:0.002063s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028097,362766,291827,671118,25175,688357,939622,151995,1005871,757227,656852,99288,195096,253998,619670,744740,798661,64928,148206,742665,1041089,565477,634834,679261,57680,908869,77493,228933,235586,859866,551365,146946,774376,174871,401063,148803,352334,475294,154960,375183,127151,186314,669677,690013,703711,62412,934177,550695,501529,644595,909481,944221,238015,1025556,585258,204855,806860,69304,256231,193016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002491s ]