SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001691s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105633 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105633 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011540,801041,269619,307440,343223,312473,693503,93777,128686,664632,639751,720025,417712,30889,335068,537640,681324,243574,745179,998718,207769,370815,417098,362941,424583,755557,333284,1010048,653475,657477,867634,214712,866278,895515,822304,1025864,910920,906204,223003,602133,496828,789111,932275,103363,491965,729480,850932,724966,279971,353134,210186,182455,324357,559967,201147,27653,23156,755945,698827,88534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]