SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597508 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597508 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267857,41659,1042369,539836,258355,299984,577450,522445,614200,1974,822096,146578,593042,1014189,213000,153410,600934,677460,1032803,742368,1039439,762719,596095,957494,626410,705885,57662,333492,298998,361181,171155,508678,885346,675867,239310,926379,943476,155267,21646,1040498,603440,814834,720066,109108,147,46434,971844,210767,177777,308451,209432,790278,244376,1001577,383370,253212,510910,971388,450980,95956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]