SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417905 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417905 [ RunTime:0.002344s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029575,171646,944023,268264,304183,857002,346487,516677,712456,42778,424411,511860,306344,528990,503882,160170,156515,301923,122543,228602,350811,49923,885005,731812,369507,892771,672143,870769,453136,352320,38968,674567,595646,416573,8209,447593,520033,703479,774174,36953,32089,798393,704348,453541,166209,251279,545402,272374,864628,989040,874332,823837,57976,910830,700978,338781,1027727,777282,842487,977571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]