SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303380 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303380 [ RunTime:0.002322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754383,523081,83402,737921,655434,435639,699740,749454,993489,893419,240993,185621,61741,104053,375461,772052,225406,366118,284226,650301,956151,633069,777963,212189,299394,198590,350126,322376,276405,430944,715405,369672,840085,867444,947254,2126,437637,75978,617571,744523,1008503,628277,325981,204481,940820,738212,509170,645235,33174,523823,601281,781177,747639,589991,399775,164373,51685,293701,104566,487649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]