SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501610 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501610 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647631,392004,418434,606947,739509,270360,635477,971082,857774,411784,533303,1032846,570706,346833,409619,356811,517126,49190,1043742,711605,1020889,449240,1000774,1025096,186671,386806,428942,723158,539086,761410,759479,801591,519476,579015,196746,709250,306742,307359,72778,103830,462700,784008,968805,51763,595351,37669,76,878122,735927,959218,397980,963003,880094,345130,179688,927679,158168,90740,838065,736768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]