SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804961 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804961 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513297,343426,304798,361583,25486,926394,485275,299189,315767,638332,974814,998245,221242,387580,764350,428406,629840,79509,56191,368845,59913,104818,870233,686676,112254,709478,847947,701712,928151,342830,839975,409895,187577,463562,241252,103229,762279,962702,184759,978413,135050,352396,383437,144012,266811,479647,821611,237041,725622,549611,732389,224526,919139,977152,674442,486032,514844,761056,471230,984710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000390s ]