SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45704 LIMIT 1 [ RunTime:0.000882s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45704 [ RunTime:0.005068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909054,641511,220755,818344,198636,681461,231944,285383,418826,701038,663011,33458,745967,999762,60470,6436,723987,39954,842890,187787,526278,93844,431757,221888,222818,50600,512152,86105,656795,528352,357707,354901,998650,431162,847293,597251,269730,172031,600579,178952,315314,633999,889467,1016608,274260,484384,942201,215793,705756,815931,832732,569671,253669,397887,503686,471583,442703,42969,826152,69703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]