SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503753 LIMIT 1 [ RunTime:0.003897s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503753 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330150,869541,298173,69030,327368,86979,749568,363962,426400,479607,129155,608174,596257,159140,779045,831937,789737,226045,368621,473786,740910,452342,375855,490699,10143,151536,346003,624580,411670,648401,164766,329107,569313,189083,337017,212418,1019065,122903,692886,542230,907735,294395,381695,551058,57862,162498,505037,1012798,494936,846718,569499,327678,8517,899461,362270,721119,902619,693271,33005,23102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]