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` = 284997 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284997 [ RunTime:0.002289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253009,26305,427423,841365,509501,325846,934137,30544,860485,206990,470355,448774,1024196,893853,197892,325112,102394,218643,39185,353331,405915,604211,68216,469762,693264,141181,394266,723595,637109,675446,578132,353469,300301,259772,711285,913422,428982,360335,472570,634042,353859,770416,422302,900448,1015188,920167,962112,638851,115248,81127,648287,851282,353221,431314,545776,43537,869839,245359,180983,5865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004129s ]