SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551984 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551984 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401543,421930,1014143,202012,992299,25466,248347,787785,962573,89458,978264,141536,893677,332719,789119,558096,272271,980451,90450,737894,724959,919400,670426,215004,114998,491716,1016449,760446,956481,831984,547391,957295,690613,505003,774445,453429,312487,695745,33481,685363,402401,275435,246860,125058,670728,742765,135695,970842,631104,732476,1042954,669568,225449,222348,851485,271734,781245,614747,732636,338170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001499s ]