SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039522 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039522 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708305,650011,144253,1012179,588514,278555,553109,236287,945908,244299,741358,655133,249202,849582,782139,836113,667254,146690,113068,201352,863123,776339,120400,1023539,87769,860736,887094,422724,28864,548500,606851,51997,397554,869467,155054,224384,663547,873818,561181,409518,309523,202824,338701,210963,600253,632503,612265,941837,106755,378369,85213,490510,933449,75149,903711,1032107,618604,635742,189198,679915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]