SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402521 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402521 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98418,810193,673419,627038,625104,141031,342429,671341,32830,51605,307689,396417,688401,747570,273882,644036,625417,557160,141507,182618,668686,548740,36769,538200,193182,435036,103363,223660,340161,1026753,708671,749755,247883,635440,674528,11282,519263,423612,576305,417638,143405,535202,80075,450671,902462,185315,928203,182730,925486,731055,906657,58995,136209,373377,1003022,175875,182597,1002743,279422,326173) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002841s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]