SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4272 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4272 [ RunTime:0.002855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415372,931112,409219,168753,642921,907463,205459,987646,537596,1045144,955870,421486,646086,342458,205243,448777,898662,566995,819465,521718,20206,934322,382368,855160,565311,521353,198497,798593,770442,966047,412133,187343,731914,693710,854817,23041,448510,149334,156361,469398,511831,218236,838517,25327,208552,741343,907739,791078,605584,966708,546966,140382,983028,544565,63719,708116,366167,341914,1011469,863040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]